﻿// bsn ModuleStore database versioning
// -----------------------------------
// 
// Copyright 2010 by Arsène von Wyss - avw@gmx.ch
// 
// Development has been supported by Sirius Technologies AG, Basel
// 
// Source:
// 
// https://bsn-modulestore.googlecode.com/hg/
// 
// License:
// 
// The library is distributed under the GNU Lesser General Public License:
// http://www.gnu.org/licenses/lgpl.html
// 
// This program is free software: you can redistribute it and/or modify
// it under the terms of the GNU Lesser General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
// 
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU Lesser General Public License for more details.
// 
// You should have received a copy of the GNU Lesser General Public License
// along with this program.  If not, see <http://www.gnu.org/licenses/>.

using System;
using System.Data;
using System.Data.SqlClient;
using System.Diagnostics;

namespace bsn.ModuleStore.Mapper {
	public sealed class ConnectionProvider: IConnectionProvider {
		private readonly string connectionString;
		private readonly string schemaName;

		public ConnectionProvider(string connectionString, string schemaName) {
			if (string.IsNullOrEmpty(connectionString)) {
				throw new ArgumentNullException("connectionString");
			}
			if (string.IsNullOrEmpty(schemaName)) {
				throw new ArgumentNullException("schemaName");
			}
			this.connectionString = connectionString;
			this.schemaName = schemaName;
		}

		private void DisplayInfoMessage(object sender, SqlInfoMessageEventArgs e) {
			Trace.WriteLine(e.Message);
		}

		public IsolationLevel DefaultIsolationLevel {
			get {
				return IsolationLevel.Unspecified;
			}
		}

		public string SchemaName {
			get {
				return schemaName;
			}
		}

		public SqlConnection GetConnection() {
			SqlConnection connection = new SqlConnection(connectionString);
			connection.InfoMessage += DisplayInfoMessage;
			return connection;
		}

		SqlTransaction IConnectionProvider.GetTransaction() {
			return null;
		}
	}
}
